Table of Contents
Simply click on the links below to jump to
a particular topic:
- Introduction
- System Requirements
- Installation Instructions
- Troubleshooting - Known Issues
Internet Database Connector Overview
With Internet Information Server and Open Data Base Connectivity (ODBC), you can:
- Create Web pages with information contained in a database.
- Insert, update, and delete information in the database based on user input from a Web page.
- Perform other SQL commands.
Web browsers submit requests to the Internet server by using the HTTP protocol. The Internet server responds
with a document formatted in HTML. This document is often referred to as a "Web page". Retrieving data from
databases is accomplished through a component of Internet Information Server (IIS) called the Internet Database
Connector (IDC). The Internet Database Connector, Httpodbc.dll, is an ISAPI DLL that uses ODBC to retrieve
data from databases. To learn more about IIS and the IDC component see the Internet Information Server Web site and IIS's On-line Help "Internet Database Connector Overview"
and "Learning the features of the Internet Database Connector".
IIS Add-In For Access 95
The IIS Add-In For Access 95 is a no-charge add-in that provides users with the ability to easily
create the appropriate IDC files HTM/IDC/HTX so one can View, Search or Insert data with any ODBC source,
such as Access 2.0 & 7.0 and SQL 6.0 & 6.5. Thus, your Web pages filled with your data can be seen by anyone using one
of the popular Web browsers. (NOTE: This Add-In also includes a Static feature that
allow you to build Static HTML pages from your Access95 Tables, Attached Tables or Queries. It was
designed to function in the same manor as the other Auto-Wizards in Access. That is,
it is a quick way to produce a Static Web page with your data and the HTML basics.)
With the increased demand for complex electronic data sharing
via the Internet or your organizations' Intranets, it has become
critical that the general business user be able to easily create
and share compelling information for these two important mediums.
With this add-in, users will be able to leverage their knowledge
of Microsoft Access without having to know sophisticated authoring
or programming languages, or the complicated code associated with
Hypertext Markup Language (HTML).
As a Microsoft Access for Windows 95 user, you have the most popular
and powerful Relational Database program available. You
know that with its popular database wizards you can quickly put
together a database structure that suits your needs. And now,
with a free add-in - IIS Add-In For Access 95
- you're just a series of buttons clicks away from putting that
same data, Tables, Attached Tables or Queries, out on the World
Wide Web.
IIS Add-In For Access 95 is a
beta release. Microsoft is aware that some features may not function
correctly. Because this is a beta release, no support is
available.
More Information
A good place to find more information on Microsoft Internet products and tools is www.microsoft.com.
This Web site contains pages that discuss Microsoft Internet Information Server specifically,
as well as providing downloadable versions of Microsoft Internet Explorer and
Microsoft Internet Assistant. Another good place to start browsing is The
Microsoft Network Web site. To get the lastest information on Access make sure you visit the
Microsoft Access Developer Forum Web site. Here you can find great tools such as the
Microsoft Access Upsizing Tools for Windows 95.
The Upsizing Tools is an update to the previous version, and provides support for Microsoft Access 95, Microsoft
SQL Server 4.21, 6.0, and the newly-released SQL Server 6.5. The Upsizing Tools enables developers to quickly and
easily migrate their Microsoft Access-based solutions to the client-server platform, while maintaining their
investment in existing applications. The Upsizing Tools are free, and can be downloaded from that page.
Return to Table of Contents
The IIS Add-In For Access 95
can be used with the following operating systems:
- Microsoft Access 95 on Microsoft Windows 95
- Microsoft Access 95 on 32-bit Windows (Microsoft Windows NT
3.51 or greater)
Return to Table of Contents
To install the IIS Add-In For Access 95
- Download the IIS Add-in for Access 95 by clicking here
- Be sure to choose "Save As..." rather than "Open"
- Save the file IISAddInForAccess95.mda to your Access 95 directory
- Start Access
- Open any Database, such as Northwind.mdb
- Select Tools|Add-Ins|Add-in Manager from the Menu
- Click on "Add New..." and select the file IISAddInForAccess95.mda, Click on "OK"
- Now that the Add-in is registered, click on "Close"
- To start the Add-in Select Tools|Add-ins|IIS Add-In For Access 95 from the Menu
Now, you're ready to start creating IDC files so you can interact with your database via the World Wide Web!
Select the Page that you wish to create and follow the instruction on the UI. When you are done
you will be presented with a Report that shows you the files that you have created and outlines what you need
to do in order to use these files, Click on the "Print" button to print this report. If you
want to modify these files simiply open the HTM or HTX file in your favorite HTML authoring application, such
as Word IA, notepad, or some other HTML authoring tool.
Return to Table of Contents
Troubleshooting - Known Issues
My Picture doesn't appear when I open my Web page.
- Your Picture is not in the same directory as the Web page.
Either put a copy of the picture in the same direct or modify
the <IMG SRC= "filename" ALT=" "> line
in your HTML document.
The Table doesn't look right when I use my browser.
- Your Browser may not support HTML Table syntax. There are
a number of Browsers available for Free on the Internet, that
do support Table syntax. You will want to upgrade your browser
to one of these. (For example Microsoft
Internet Explorer is available for free)
When I position my image on the Right it doesn't show up above
the Header and text:
- This is by default with HTML code. Pictures aligned Left
or Center show above the Header and text, while Aligned Right
pictures will show up parallel to the Header and in some cases
your text and table may overlap the picture.
- To resolve this you can open your HTM file in notepad or Word
IA and add a number of <BR>, the equivalent to a soft
return, after the <IMG SRC > syntax. The height of the picture will determine how many
<BR>'s you will need to insert in the HTML document.
Why is my Header always Bold?
- This is the Default appearance of a Header, you can change
the <H1> to another HTML syntax after opening the HTML document
in Word IA, notepad, or some other HTML authoring tool.
Why can't I change the Font Size of my Header and Additional text?
- The Font Size setting for HTML is different then that which
Windows uses. To change the Size of your Font you can use the
<FONT SIZE=?></FONT> where ? ranges from 1-7, within
your HTML document.
The Font Style I selected for my text appears fine on my machine,
but when I view my page from another machine it is not the same
Style.
- If the Font you have selected is not available on another
machine, a default font will be used.
For more information on HTML syntax see
HTML Reference or search any one of the Search pages on the Internet
for additional HTML Language sites.
Return to Table of Contents
© 1995 Microsoft
Corporation. All rights reserved. Microsoft, Microsoft Access
for Windows 95, Microsoft Office, Windows, Windows NT, Windows
95, Microsoft Network, and Microsoft TechNet are either registered
trademarks or trademarks of Microsoft Corporation in the United
States and/or other countries.